select tttID, ttName, ttCity, ttTecmoOrder, ttoff, franchise from standings where tttID = 42 - DB AND ttlUID = 1 AND ttsUID = 7